Connection string - VisualCron - Forum

Community forum

Dark_Light
2008-04-25T13:05:29Z
How should the connection string look? I cant get it to work
Support
2008-04-25T16:40:43Z
It depends..check out http://www.connectionstrings.com/ 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Dark_Light
2008-05-06T14:24:18Z
it says: Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Mine looks like: "Provider=Microsoft.Jet.OLEDB.4.0;Password= ;User ID= ; Data Source=" & Server.MapPath("c:/inetpub/wwwrot/browsergame/db/db12.mdb")

I don't know what's wrong...
Support
2008-05-06T18:55:46Z
Server.MapPath is a ASP.NET function and cannot be used in a connection string. I would create the connection string in the ODBC/OLEDB editor in Administrive tools. Then you can use the DSN name instead.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Dark_Light
2008-05-06T21:05:08Z
administrative tools? in visualCron?
Support
2008-05-06T21:25:54Z
No, control panel in windows
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Dark_Light
2008-05-06T22:42:11Z
how do I find the relevant path? File-DSN?
Support
2008-05-06T22:46:44Z
You use system dsn and use the name you want. You should put the name you use into VisualCron.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Dark_Light
2008-05-06T22:47:57Z
what driver should I pick?
Support
2008-05-06T22:51:19Z
I don't know what database you use but probably the Microsoft Access driver.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Dark_Light
2008-05-06T23:00:47Z
what should the provider tag contain? what's SQLOLEDB?
Support
2008-05-06T23:04:41Z
Actually I don't know as I am no expert on sql strings. But if you can't find it here: http://www.connectionstrings.com/  I would test to use original string that you posted but with the absolute path to the .mdb file (and not use the ASP.NET function).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
mars
2008-05-07T22:38:45Z
Hi, I have a little hint for you. With an UDL-File you can easy build connectionstrings.
Link to MSDN: http://msdn.microsoft.com/en-us/library/e38h511e (VS.71).aspx

After saving the UDL-File you can open the File with a notepad and copy the connectionstring in the SQL Task.
Scroll to Top