Search results for query: *

Sounds like DLL hell to me ? What versions of operating system, IIS and ODBC have you installed and have you installed patches for these ? Another thing to try would be to create a small app (in VB or whatever) that connects to the DSN and see if this works ok. If it does then I suspect the...

Sorry just read that you get the error using the DSN test button... Have you tried switching the Client Configuration to use Named Pipes instead of TCP/IP ?

Where you setup up your DSN in the ODBC Data Source Administrator via control panel there is a button to test the connection Make sure your DSN is a System and not a User DSN Assuming you call your DSN "mySQL" then once the connection is verified try... Conn.Open...

I assumed u are using SQL as mySql was name but with Access you need to specify an Access driver.. try.. Conn.Open "driver={Microsoft Access Driver (*.mdb)}; server=localhost;uid=root;pwd=password;database=Trading" or maybe Conn.Open "driver={Microsoft Access}...

When you tried a DSN did the connection work through the ODBC Administration area ?? If so what was the code you tried in the ASP ?

thanks but unfortunately the web server is running SQL7 so BIGINT is not available. I am trying to tackle it from the ADO angle using GetChunk to get the binary recordset field value but keep getting an exception "ADODB.Field operation not allowed" although I am using an ASP code...

Thanks for that I have printed that article. However this only works with .NET and IIS5.1 or higher. Anything similar for IIS4.x under NT4.0 ?

You haven't really stated your problem ? What do you mean "not being recognized" ? Does you ASP code not find the table or does the table not exist in SQL after your conversion ? "Are there any known problems with tables not being recognized in a converted db?" - very...

thanks but I have looked at the filesystemobject... and yes with this I can get a list of recursive directories on my system and get lots of properties but as far as I can see I cannot test each folder to see if it has a virtual alias set up on the web server. The tricky bit is that I might...

When a trigger fires you have access to the table before and after the update/delete so you could store the variable in the actual table and use it in the trigger code...

I would like to dynamically display a list of web applications I have running on IIS as href links so the user can go directly to any new web applications that have been added to the web site from the root application. I know you can return a physical directory location given a virtual...

Tried it but still the conversion back was not correct.. SQL Help says binary field conversions to varchar,nchar, nvarchar are truncated. It seems incredible that there is no long datatype in SQL as in C++ since this would hold the number. SQL Help says binary conversions to float and real not...

I have not set up this binary field but need to use it in a dropdown list for users to choose from. All binary fields are ultimately just numbers but this is just a very long one (8 bytes) SQL won't allow conversion to float and although money works since its 8 bytes, the conversion back to...

Response.Write(x.value) is the value of the column Response.Write(x.name) is the name of the column

I have a column that stores numbers as 8 byte binary hex numbers eg. 0x0040000000000009 My problem is when I get this column in an ADO recordset I cannot access the value to show in an ASP page as a meaningfull number. The ADO recordset stores it as an array of bits which I don't know how to...

I have a column that stores numbers as 8 byte binary hex numbers eg. 0x0040000000000009 My problem is when I get this column in an ADO recordset I cannot access the value to show in an ASP page as a meaningfull number. The ADO recordset stores it as an array of bits which I don't know how to...