Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Blim #1
Data source name too long (asp)
I am using asp and I am trying to set up a custom connection string using the
Dreamweaver menus. I have entered the following into the Connection String
textbox on the Custom Connection String dialog:
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &
Server.MapPath('\Resources\Resources.mdb');' When I click the test button I
get the error: [Microsoft][ODBC Driver Manager] Data source name too long I
have moved the database to make the path shorter, but this has not worked. I
have ticked the 'Using driver on test server ' button. The full path to the
database on the test server (which is on my local machine) is:
C:\Inetpub\wwwroot\Kulika\Resources\Resources.mdb which doesn't seem too long
to me. Can anybody see what I am doing wrong? Ian
Blim Guest
-
Error:data Source Name too long
When trying to set up a custom connection string by entering: \\Ib27s17\data\Production Databases\Contact Info Database\Contact Information... -
moving data from one data source to another
I'm trying to move data from one data source to another. I don't want to loop - because it will kill performance. A simple Select into or Insert... -
Error - Data source name too long
Hello, Well I'm finally switching to DSN-Less connection! But, of course, the transition has not been without error :+) Here is my error:... -
inserting into a long data type
> I don't have the access or authority to change the data type from long Unlikely. Try using SQL*Loader for this. Too bad you can't change the... -
max size of data in a LONG column
Hi Deepak, Max size is 2G. Length(long) is invalid. Don't know which version you're on but look at using a clob instead. Longs should be... -
Blim #2
Re: Data source name too long (asp)
I think I have spotted my deliberate error, the extra set of quotes at the end.
However, I still have a problem. My string now reads:
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &
Server.MapPath('\Resources\Resources.mdb') This produces the following error:
C:\inetpub\wwwroot\Resources\Resources.mdb is not a valid path. It looks as
though the MapPath command is missing out the root folder of the site. The
database is actually on C:\inetpub\wwwroot\Kulika\Resources\Resources.mdb
(i.e. in a subfolder of the main IIS area called Kulika I am confused. The
location of the test site is set up as C:\inetpub\wwwroot\Kulika\.
Blim Guest



Reply With Quote

